SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_UpdateFileLink]
    (
      @JOL_File_No INT,
      @JOL_File_Title VARCHAR(100),
      @JOL_File_Type VARCHAR(50),
      @JOL_File_FileUrl VARCHAR(255),
      @JOL_File_Remark NTEXT,
      @JOL_File_UpdateTime DATETIME,
      @JOL_File_UpdateUser VARCHAR(50)
    )
AS 
    UPDATE  dbo.JOL_FileLink
    SET     JOL_File_Title = @JOL_File_Title,
            JOL_File_Type = @JOL_File_Type,
            JOL_File_FileUrl = @JOL_File_FileUrl,
            JOL_File_Remark = @JOL_File_Remark,
            JOL_File_UpdateTime = GETDATE(),
            JOL_File_UpdateUser = @JOL_File_UpdateUser
    WHERE   JOL_File_No = @JOL_File_No
GO
